CREATE TABLE [dbo].[Product_Cert]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_PRODUCT_CODE] DEFAULT (''),
[PARENT] [bit] NOT NULL CONSTRAINT [DF_Product_Cert_PARENT] DEFAULT ((0)),
[UNITS_REQUIRED_FOR_CREDIT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Cert_UNITS_REQUIRED_FOR_CREDIT] DEFAULT ((0)),
[DEPENDENT_FUNCTIONS] [int] NOT NULL CONSTRAINT [DF_Product_Cert_DEPENDENT_FUNCTIONS] DEFAULT ((0)),
[TIE_TO_PROGRAM] [bit] NOT NULL CONSTRAINT [DF_Product_Cert_TIE_TO_PROGRAM] DEFAULT ((0)),
[SKIP_ENROLLMENT] [bit] NOT NULL CONSTRAINT [DF_Product_Cert_SKIP_ENROLLMENT] DEFAULT ((0)),
[ADDRESS_1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_ADDRESS_2] DEFAULT (''),
[ADDRESS_3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_ADDRESS_3] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_ZIP] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Cert_COUNTRY] DEFAULT (''),
[INSTRUCTORS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PREREQUISITES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CURRENTLY_ENROLLED] [int] NOT NULL CONSTRAINT [DF_Product_Cert_CURRENTLY_ENROLLED] DEFAULT ((0)),
[TOTAL_PASSED] [int] NOT NULL CONSTRAINT [DF_Product_Cert_TOTAL_PASSED] DEFAULT ((0)),
[TOTAL_FAILED] [int] NOT NULL CONSTRAINT [DF_Product_Cert_TOTAL_FAILED] DEFAULT ((0)),
[BEGIN_DATE] [datetime] NULL,
[END_DATE] [datetime] NULL,
[SUBCOMPONENT] [bit] NOT NULL CONSTRAINT [DF_Product_Cert_SUBCOMPONENT] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Product_Cert] ADD CONSTRAINT [PK_Product_Cert] PRIMARY KEY NONCLUSTERED ([PRODUCT_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_Cert] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_Cert] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_Cert] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_Cert] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_Cert] TO [IMIS]
GO